//=============================================================================
//===	Copyright (C) 2001-2005 Food and Agriculture Organization of the
//===	United Nations (FAO-UN), United Nations World Food Programme (WFP)
//===	and United Nations Environment Programme (UNEP)
//===
//===	This program is free software; you can redistribute it and/or modify
//===	it under the terms of the GNU General Public License as published by
//===	the Free Software Foundation; either version 2 of the License, or (at
//===	your option) any later version.
//===
//===	This program is distributed in the hope that it will be useful, but
//===	WITHOUT ANY WARRANTY; without even the implied warranty of
//===	MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
//===	General Public License for more details.
//===
//===	You should have received a copy of the GNU General Public License
//===	along with this program; if not, write to the Free Software
//===	Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
//===
//===	Contact: Jeroen Ticheler - FAO - Viale delle Terme di Caracalla 2,
//===	Rome - Italy. email: GeoNetwork@fao.org
//==============================================================================

package org.fao.geonet.services.param.branch;

import java.util.ArrayList;
import java.util.HashSet;
import java.util.Iterator;
import java.util.Set;
import jeeves.constants.Jeeves;
import jeeves.interfaces.Service;
import jeeves.resources.dbms.Dbms;
import jeeves.server.ProfileManager;
import jeeves.server.ServiceConfig;
import jeeves.server.UserSession;
import jeeves.server.context.ServiceContext;
import org.fao.geonet.constants.Geonet;
import org.fao.geonet.constants.Params;
import org.fao.geonet.util.HLog;
import org.jdom.Element;

//=============================================================================

/**
 * Retrieves all users in the system
 */

public class List implements Service {
	// --------------------------------------------------------------------------
	// ---
	// --- Init
	// ---
	// --------------------------------------------------------------------------

	public void init(String appPath, ServiceConfig params) throws Exception {
	}

	// --------------------------------------------------------------------------
	// ---
	// --- Service
	// ---
	// --------------------------------------------------------------------------

	public Element exec(Element params, ServiceContext context)
			throws Exception {
		UserSession session = context.getUserSession();

		if (!session.isAuthenticated())
			return new Element(Jeeves.Elem.RESPONSE);

		Dbms dbms = (Dbms) context.getResourceManager()
				.open(Geonet.Res.MAIN_DB);

		String id_organization = params.getChildText("id_organization", null);
		String id_branch = params.getChildText("id_branch", null);

		if (id_organization == null)
			throw new Exception("Invalid arguments, missing organization id");
		Element elEntityMaster = new Element(Geonet.Elem.RECORD);
		// Element elements = dbms.select ("SELECT * FROM organization_branch A
		// WHERE id_organization = " + id_organization + " ORDER BY name");
		Element elDetail2 = new Element(Geonet.Elem.BRANCHES);
		Element elDetail3 = new Element(Geonet.Elem.AREA);
		elDetail2
				.addContent(dbms
						.select("SELECT DISTINCT B.id AS id_branch, B.name FROM organization_branch B, area A WHERE B.id = A.id_organization_branch AND id_organization = "
								+ id_organization));

		if (id_branch != null && !id_branch.equals(""))
			elDetail3
					.addContent(dbms
							.select("SELECT A.id AS id_area, A.name FROM area A WHERE id_organization_branch = "
									+ id_branch));
		elEntityMaster.addContent(elDetail2);
		elEntityMaster.addContent(elDetail3);

		return elEntityMaster;
	}
}

// =============================================================================

